CustomerServiceWorkOrderAccount

Entity Definition

Logical Name : CustomerServiceWorkOrderAccount
Physical Name : LE_CT_SV_WRK_ORD_ACNT

A customer account type created to track initial deposit, payment, refund and other financial actions related to delivering a service to a customer. For example customer A purchases a garage door from retailer X. The customer pays for the garage door. In addition the customer pays a deposit of $100 for installation service ( work order) . Upon completion of the installation the customer pays the remaining balance for the service of $200. This entity captures the initial deposit and susbequent payment. It also links them to a work order (or potentially a PO if the installer is an outside firm.)

Data Definition

Attribute	Description	Physical Name	Domain	Data Type	Foreign Key Table
CustomerAccountID (FK)(PK)	A unique identifier for a customer account.	ID_CTAC	Identity	integer
ServiceProviderID (FK)	A unique system assigned identifier for the Service Provider.	ID_PVR_SV	Identity	integer	ServiceProvider(PA_PVR_SV)
WorkOrderNumber	A unique number used to identify the work order document associated with this CustomerServiceWorkOrder,.	AI_WRK_ORD	IdentityAlphaNumeric	varchar(20)
WorkOrderDepositAmount	The amount of money a customer pays to secure a service. It is typically a prepayment and is subtracted from the final invoice amount for the service provided	MO_WRK_ORD_DS_AMT	Money	decimal(16,5)

Relationships

Parent Entity	Verb Phrase	Child Entity
ServiceProvider	charges services to	CustomerServiceWorkOrderAccount

Logical Views containing CustomerServiceWorkOrderAccount

Logical View
Logical 07010 - Customer Account Information Extended